﻿<%@ Page Title="Transaction Page" Language="C#" MasterPageFile="~/Home.Master" AutoEventWireup="true" CodeBehind="frmTransaction.aspx.cs" Inherits="DomesticPestProject.frmTransaction" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder6" runat="server">
         <table style="width: 180px">
         <tr>
         <td>
         &nbsp;&nbsp;<asp:Button ID="btnCommodity" runat="server" Text="Commodity" 
                  Width="140px" Font-Bold="True" ForeColor="Black" onclick="btnCommodity_Click" 
                  />
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         
         &nbsp;&nbsp;<asp:Button ID="btnInformation" runat="server" Text="Information" 
                 Width="140px" Font-Bold="True" ForeColor="#000066" onclick="btnInformation_Click" 
                 />
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         &nbsp;&nbsp;<asp:Button ID="btnTransaction" runat="server" Text="Transaction" 
                 Width="139px" Font-Bold="True" ForeColor="#000066" />
         
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
          &nbsp;&nbsp;<asp:Button ID="btnPest" runat="server" Text="Pest" Width="140px" 
                 Font-Bold="True" ForeColor="#000066" onclick="btnPest_Click" 
                 />
         
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         &nbsp;&nbsp;<asp:Button ID="btnLctn" runat="server" Text="Location" Width="138px" 
                 Font-Bold="True" ForeColor="#000066" onclick="btnLctn_Click" />
                
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         
         &nbsp;&nbsp;<asp:Button ID="btnPsDsrbtn" runat="server" Text="Pest Distribution" 
                 Width="138px" Font-Bold="True" ForeColor="#000066" 
                 onclick="btnPsDsrbtn_Click" />
         </td>
         
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         
         &nbsp;&nbsp;<asp:Button ID="btnMain" runat="server" Text="Main Page" 
                 Width="138px" Font-Bold="True" ForeColor="#000066" 
                 onclick="btnMain_Click" />
         </td>
         
         </tr>
         </table>
         </asp:Content>
<asp:Content ID="Content7" ContentPlaceHolderID="ContentPlaceHolder7" runat="server">

<table style="margin-top: 0px">
    <tr>
        
        <td class="style7">
        <table>
        <tr>
         <td >
        
             <asp:Label ID="lblTransCd" runat="server" Text="Transaction Code" 
                 Font-Size="Smaller"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:TextBox ID="txttCd" runat="server" Height="12px" 
                 Width="154px" Font-Size="Smaller"></asp:TextBox>
        </td>
        
        </tr>
        <tr>
        <td >
            &nbsp;&nbsp;<asp:Label ID="lblPest" runat="server" Text="Pest :" 
                Font-Size="Smaller"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:DropDownList ID="ddlPest" runat="server" Height="24px" 
                 Width="154px" Font-Size="Smaller" DataSourceID="SqlDataSource3" 
                 DataTextField="SNAME" DataValueField="SNAME">
             </asp:DropDownList>
             <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                 ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                 SelectCommand="SELECT DISTINCT SNAME FROM Pest"></asp:SqlDataSource>
        </td>

    </tr>
        </table>
        
        </td>
        <td >
        <table>
        <tr>
        <td>
              <asp:Label ID="lblState" runat="server" Text="State :" 
                  Font-Size="Smaller"></asp:Label>
        </td>
        <td>
              
                  &nbsp;&nbsp;<asp:DropDownList ID="ddlState" runat="server" Height="18px" 
                 Width="154px" Font-Size="Smaller" DataSourceID="SqlDataSource4" 
                      DataTextField="State_Name" DataValueField="State_Name"> </asp:DropDownList>
                  <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                      ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                      SelectCommand="SELECT DISTINCT State_Name FROM Country"></asp:SqlDataSource>
        </td>
    </tr>
    <tr>
        <td>
             &nbsp;&nbsp;<asp:Label ID="lblHost" runat="server" Text="Host :" 
                 Font-Size="Smaller"></asp:Label>
        </td>
        <td >
             &nbsp;&nbsp;<asp:DropDownList ID="ddlHost" runat="server" Height="18px" 
                 Width="154px" Font-Size="Smaller" DataSourceID="SqlDataSource5" 
                 DataTextField="CNAME" DataValueField="CNAME"> </asp:DropDownList>
             <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                 ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                 SelectCommand="SELECT CNAME FROM Commodity"></asp:SqlDataSource>
          </td>       
    </tr>
        </table>
        
        </td>
       
    </tr>
    
    



    <tr>
        
        <td class="style7">
           &nbsp;&nbsp;<asp:Label ID="lblInfo" runat="server" Text="Information :" 
                Font-Size="Smaller"></asp:Label>
        </td>
        <td>
          <asp:ListBox ID="lstInfo" runat="server" Height="44px" Width="205px" 
                style="margin-top: 0px" Font-Size="Smaller" DataSourceID="SqlDataSource2" 
                DataTextField="Expr1" DataValueField="Expr1" SelectionMode="Multiple"></asp:ListBox>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                SelectCommand="SELECT { fn CONCAT(Author, year) } AS Expr1 FROM info">
            </asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                SelectCommand="SELECT Author, year FROM info"></asp:SqlDataSource>
        </td>
        <td>
           <table>
           <tr>
           <td>
           <asp:Button ID="btnaddlist" runat="server" Text="Add >>"  
                   Font-Size="Smaller" Height="20px" Width="81px" 
                   onclick="btnaddlist_Click" />
           </td>
           </tr>
           <tr>
           <td>
           <asp:Button ID="btnRemove" runat="server" Text="<< Remove" 
                   Font-Size="Smaller" Height="20px" onclick="btnRemove_Click" />
           </td>
           </tr>
           
           </table>
            
            
        </td>
        <td class="style4">
        <asp:ListBox ID="lstAddRmvInfo" runat="server" Height="44px" Width="205px" 
                Font-Size="Smaller" SelectionMode="Multiple"></asp:ListBox>
        
        </td>  
    </tr>
    <tr>
    
    <td class="style7">
        &nbsp;&nbsp;<asp:Label ID="lblPlantparts" runat="server" Text="Plant Part :"></asp:Label>
        <asp:CheckBoxList ID="chkPlantparts" runat="server" Height="16px" 
            Width="178px" Font-Size="Smaller">
            
            <asp:ListItem>Seed</asp:ListItem> 
            <asp:ListItem>Seedling</asp:ListItem>
           
            <asp:ListItem>Stem</asp:ListItem>
            <asp:ListItem>Leaf</asp:ListItem>
            <asp:ListItem>Infloresence</asp:ListItem>
            <asp:ListItem>Fruit</asp:ListItem>
            <asp:ListItem>Root</asp:ListItem>
            <asp:ListItem>All Parts</asp:ListItem>
            <asp:ListItem>Whole Parts</asp:ListItem>
            <asp:ListItem>Unknown</asp:ListItem>
        </asp:CheckBoxList>  
    </td>
    <td>
    <asp:TextBox ID="txtStoreplantparts" runat="server" Height="12px" 
                 Width="154px" Font-Size="Smaller" Visible="False"></asp:TextBox>
                 
    
    
    </td>
    
    </tr>
   
</table>
<table>
 <tr>
    <td class="style3">
        <asp:Button ID="btnAdd" runat="server" Text="Add" Height="20px" 
            Font-Size="Smaller" Enabled="False" />
    </td>
    <td class="style3">
        <asp:Button ID="btnModify" runat="server" Text="Modify" Font-Size="Smaller" 
            Height="20px" />
    </td>
    <td class="style3">
        <asp:Button ID="btnDelete" runat="server" Text="Delete" Font-Size="Smaller" 
            Height="20px" />
    </td>
    <td class="style3">
        <asp:Button ID="btnListing" runat="server" Text="Listing" Font-Size="Smaller" 
            Height="20px" onclick="btnListing_Click" />
    </td>
    <td class="style3">
        <asp:Button ID="btnSave" runat="server" Text="Save" Font-Size="Smaller" 
            Height="20px" onclick="btnSave_Click" />
    </td>
    <td class="style3">
        <asp:Button ID="btnCancel" runat="server" Text="Cancel" Font-Size="Smaller" 
            Height="20px" />
    </td>
    <td class="style3">
       <asp:Button ID="btnExit" runat="server" Text="Exit" Font-Size="Smaller" 
            Height="20px" />
    </td>
    </tr>
</table>
<p>
</p>
<asp:Panel ID="Panel1" runat="server">
        <asp:GridView ID="gvTrans" runat="server" BackColor="White" BorderColor="White" 
            BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" 
            ForeColor="#003366" GridLines="None" 
            onrowcancelingedit="gvTrans_RowCancelingEdit" onrowediting="gvTrans_RowEditing" 
            onrowupdating="gvTrans_RowUpdating" ShowHeaderWhenEmpty="True" Width="639px" 
            onrowdeleting="gvTrans_RowDeleting">
            <Columns>
                <asp:CommandField HeaderText="Delete" ShowDeleteButton="True" 
                    ShowHeader="True" />
                <asp:CommandField HeaderText="Edit" ShowEditButton="True" ShowHeader="True" />
            </Columns>
            <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
            <HeaderStyle BackColor="#003366" Font-Bold="True" ForeColor="#97CBFF" />
            <PagerStyle BackColor="#B3D9FF" ForeColor="#003366" HorizontalAlign="Right" />
            <RowStyle BackColor="#BFBFFF" ForeColor="#003366" />
            <SelectedRowStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#F1F1F1" />
            <SortedAscendingHeaderStyle BackColor="#594B9C" />
            <SortedDescendingCellStyle BackColor="#CAC9C9" />
            <SortedDescendingHeaderStyle BackColor="#000066" />
        </asp:GridView>
    </asp:Panel>
    <table>
    <tr>
    <td>
     <asp:TextBox ID="txtPest" runat="server" Height="12px" 
                 Width="154px" Font-Size="Smaller" Visible="False"></asp:TextBox>
    <asp:TextBox ID="txtState" runat="server" Height="12px" 
                 Width="154px" Font-Size="Smaller" Visible="False"></asp:TextBox>
    <asp:TextBox ID="txtHost" runat="server" Height="12px" 
                 Width="154px" Font-Size="Smaller" Visible="False"></asp:TextBox>
                  <asp:TextBox ID="txtInfo" runat="server" Height="12px" 
                 Width="154px" Font-Size="Smaller" Visible="False"></asp:TextBox>
    </td>
    </tr>
    </table>
</asp:Content>
<asp:Content ID="Content8" runat="server" 
    contentplaceholderid="ContentPlaceHolder1">
    <style type="text/css">
        .style3
        {
            height: 14px;
        }
        .style4
        {
            height: 17px;
        }
        .style6
        {
            width: 148px;
        }
        .style7
        {
            width: 325px;
        }
    </style>
   
</asp:Content>

